Комментарии:
Very helpful. One question - in the first trick, the numbers are showing the comma separator between million/thousand after two digits. What causes that?
ОтветитьIs it not possible to define a detail row expression in power bi? Is this type distinction visible in the semantic layer of power bi?
ОтветитьGreat! thank u
ОтветитьSir in the first trick letz suppose I have multiple visuals in the page and I want to do it only for a particular visual and for the rest of the visual it shud pick it from the slicer but in your case it is disconnected table how to achieve it then?
ОтветитьWow. The detailrows function? ..i did not know about it! Great but I really don’t like that this is not possible from clean BI (without Tabular editor)
ОтветитьThree fantastic tricks that seem simple after the explanation, but only because of your great ability to make complicated things simple.
Thank you for sharing this tutorial.
Stellar video! I am also really enjoying your courses!
ОтветитьAll 3 are fantastic!!!
ОтветитьThis is a great idea, thank you. In the disconnected table, you can have only Month & Year field if the intention is to use it as a slicer . Store less fields , lesser the size of the pbix file.
ОтветитьThanks :)) Useful tricks
ОтветитьI like the second trick. I was looking for a solution similar to that, where I can store the logic of the time intelligence calculation, for example YTD/QTD/MTD/PY in one place. My hope is to keep all the logic of the time filters in one place, and then apply those filters to the actual measures like Total Sales YTD/QTD/MTD/PY, Total Cost YTD/QTD/MTD/PY, Total Qty YTD/QTD/MTD/PY. By doing that, we will make sure the time intelligence are calculated at the exact time frame across the board
ОтветитьFor the first trick, I guess that It works too using SELECTED VALUE instead of MAX, right?
ОтветитьVery Nice
ОтветитьTnx
ОтветитьWow, I have not seen that coming! This is simply amazing.
ОтветитьVery good content. Thank you soo much
ОтветитьFirst one most useful for me- but all 3 are great 🎉
ОтветитьThe second trick is brilliant! Thank you, didn't know about it, it will come in really useful when I need a complicated filter :)
ОтветитьWell done Boss. ❤
ОтветитьGreat video.
Regarding the 1st trick. Can we implement the same without additional table.?
Captured the relevant month in Dax
Add remove filter
And filter by less than the relevant date.
Pretty similar to what you showed but replace the additional table by bit complex Dax code probably
Thanks again. Moving to trick #2😂
Great
ОтветитьTnx. Really great!
Ответить2nd: need to check if that will work for RLS
ОтветитьGoodly by name, Goodly by nature 👍
ОтветитьAwesome, all three are great especially the third trick. Thanks Chandeep
ОтветитьAll the three tricks are awesome😊 The first one is very creative that creating a table reference to the Calendar. The second one is like calculation group a bit, cool! The last one is Wow, never think of that strick equal sign😮
ОтветитьChandeep your ability to breakdown such complex topics and teach them so well is simply amazing
ОтветитьSuch useful tricks , 2nd one was something i didn't knew about , Got to learn something new , thanks Chandeep!!
ОтветитьThe trick number 3 helps understand why (NOT ISBLANK && <>0) and (<>BLANK && <>0) may return very different results …
Ответить