October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hello,
Please see a screenshot where you can see that I have used the “Sales and Marketing Sample PBIX” PBI that can be downloaded from Microsoft website. On the left I have a date table where I have selected one day. The table on the left shows the transactions done on that date with the parameters.
What I want to achieve is on the right side, ALL the transactions done in the whole month. So, if I select the 15th of a certain month I want to see all the transactions done in that month, including the ones done after the 15th.
Is it possible to achieve this in DAX?
Thanks,
Naveen
Solved! Go to Solution.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh3yuIDulN_IdBCdh?e=utQYHH
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rh3yuIDulN_IdBCdh?e=utQYHH
User | Count |
---|---|
104 | |
97 | |
96 | |
85 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |