Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm still relatively new to Power BI and the one area I'm having consistent struggle with is the MTD and PMTD measures.
The measures are built using these variations (I've tested them all and can't seem to get the same number as when I drop the column into the Card and then add the Relative Date n filter of "In the Last 1 Calendar Month"). I don't need prior MTD/YTD, I need actual calendar month total.
Test #1 -
@AppGuySCS You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Thanks @Greg_Deckler , I'll give this a read.
Here's a little more detail to my question: