The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have created a Dax logic to calculate prior year values as below :
FY Prior Year Values=
Can you please help filtering these values for only Current FY (in DAX) ?
Thanks in Advance!
Solved! Go to Solution.
Maybe you can try this:
FY Prior Year Values (New) = IF(ISBLANK([FY_Values]), BLANK(), [FY Prior Year Values])
Let me know if it solves your issue.
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Thanks solutions from @Ashish_Mathur and @quantumudit , your solutions is great!
Hi, @Saloni_Gupta
You can put your FY Values measure into a Filter pane visual filter and set it to non-null. I created a sample as follows:
I have two measures, value_1 and value_2, and there are some empty items in the value_1.:
I put the value_1 measure in the Filter pane next to it and set it to "is not blank"
The results are shown in the figure below:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Try this approach
Total = sum(Data[Amount])
Hope this helps.
Maybe you can try this:
FY Prior Year Values (New) = IF(ISBLANK([FY_Values]), BLANK(), [FY Prior Year Values])
Let me know if it solves your issue.
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |