Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello
To get the latest data out of the fact, I made a calculated column in Power BI, which I can use to filter my page.
If I choose the value 1 for that filter, I will get the latest month with data in the fact.
When I copy this calculated column to Report Server, I get an error.
I tried using selectedvalue but then my filter never finds a match, so only returns 0
Below my code and the error message (sorry, the formatting doesn't transfer for some reason)
Are you sure this is a measure in Power BI Desktop? Smells more like a calculated column.
Oops, indeed!
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
1 |
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 |