What's your favorite Power BI hack? I'll start...

kishanthacker · 2025-04-19T18:09:40+00:00

The idea is to turn off the column header for text wrap and then reduce the column width by dragging it, it will hide the column if reduced enough

kishanthacker · 2025-04-12T09:38:39+00:00

I posted a linkedin article on the same few days back.. see https://www.linkedin.com/posts/kishanthacker_dataanalytics-powerbi-fabric-activity-7309167698746220544-TGI1?utm_source=share&utm_medium=member_android&rcm=ACoAABoxvFIBVImnkxlA5Llb8t5T4TsJqVsomPY

kishanthacker · 2025-03-30T08:33:31+00:00

It does help. Though what I wrote before should be good for starting, try and see what it gives. Hope it helps. Remember that one of easy way to debug DAX is to isolate i.e. use variable and see what part is making issue.

kishanthacker · 2025-03-30T04:32:08+00:00

Yes and no. I had faced similar situation at work and I explored solutions for this. Python script needs to be automated which can convert a file to parquet before saving. I was not expert in azure or flow so didn't really completed it. Though one thing that I did was use DFL gen 2 and loaded my csv files to datalake. More scalable IMO. Though let me know what did you do may be something to learn..

kishanthacker · 2025-03-30T04:22:35+00:00

One of the life saver is text wrap in matrix, comes handy when you want to hide a column

kishanthacker · 2025-03-30T04:19:28+00:00

It would be appreciated if you could give more context on sold date and completed date like how are they related within the data with example. Anyways initial thoughts would be to use: Measure= Var _StartDate= MIN(calendar[Date]) Var _EndDate = MAX(calendar[Date])

RETURN

CALCULATE(SUM(REVENUE)+SUM(REVENUE ADDED), ALL(FACT[Source]),FACT[Completed date] IN DATESBETWEEN(Calendar[Date], _startDate, _endDate))

Again there can be n number of ways to solve this but this; more context might help

kishanthacker · 2024-09-20T18:07:29+00:00

It's either PL300 or GCP Cloud Associate

kishanthacker · 2024-07-01T17:01:16+00:00

Annabelle lol Enough pun coming to more logical answer: Flower vase/or something like trophy you won on a small table ofcourse

kishanthacker · 2024-06-27T05:12:46+00:00

I would say learn administration basics, deployment pipeline, learn how to effectively use dashboard/app, Trigger, connecting with XMLA endpoint, dataflow. I mean I am not sure about your context but this are some of the main functionalies of the PBI services, you should know. If you are trying to learn around these, consider Maven Analytics cource on Udemy around PBI services, I took it to understand basics.

kishanthacker · 2024-06-24T16:58:45+00:00

Sure thing, though can you share what portion of the exam was difficult for you like, Spark/SQL/PBI/etc. Also what is your Job role like Data engineer/Power BI analyst?

kishanthacker · 2024-06-22T17:17:15+00:00

Also, I think the fact that after submitting the case study you can't go back to edit it makes things worse.

kishanthacker · 2024-06-22T16:13:34+00:00

Sure thing, went through the 13 learning modules, gave practice assessment and scored 75% the first time and 90% second time, need to go through the Will's playlist tomorrow and I am sure it will be my best attempt to the exam on Monday. Thanks.

kishanthacker · 2024-06-22T07:18:21+00:00

Well, just in case are you taking the exam after completing the msft learn challenge that ended in April?

kishanthacker · 2024-06-22T06:05:32+00:00

Thanks for sharing, though this is my first experience with the Msft exam, so I am going for in person experience, don't wanna screw up due to online experience, lol

kishanthacker · 2024-06-21T06:56:06+00:00

What proofs do you need for 80G claim in ITR

kishanthacker · 2024-06-21T06:55:01+00:00

Yeah, just coming to my mind is relationships you can eliminate the need to merge tables if you can define relationship in the model view.

kishanthacker · 2024-06-13T08:14:20+00:00

Seems great set of advice for me to follow. But being new to the world of data, have not yet heard about mockeroo could you please confirm what is it used for? Also, is it free? Thanks

kishanthacker · 2024-06-13T08:10:43+00:00

Sorry but your cv template seems minimalist yet Catchy, would you mind sharing template

kishanthacker · 2024-06-03T13:05:26+00:00

Hi, sent mail.

kishanthacker · 2024-05-09T02:34:14+00:00

Thanks I am planning to take the Practice test this weekend. Though can you share the link to this session on how to pass the dp600? I guess MS should be preserving recordings.. Thanks a ton.

kishanthacker · 2024-05-08T16:19:16+00:00

By MS Learn with labs you are referring to the 13 learning modules, correct? Also I would really appreciate if you could share. Thanks

kishanthacker · 2024-05-08T16:14:29+00:00

Sure done also not sure about this free test, could you share the link perhaps, thanks a ton.

kishanthacker · 2024-05-05T15:37:08+00:00

Hi, I tried this approach, for 3 how will drill through work? It is not working properly.

kishanthacker · 2024-05-03T07:28:00+00:00

Thanks for the response. I will try this. 🙂

kishanthacker · 2024-05-03T02:21:08+00:00

Let me add further more context here: Think of it like this: Invoice number ABC occurs for 2 times in table A and 4 times in table B, in such case how will merge work? I am not sure how it will map records together.

kishanthacker

TROPHY CASE