Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Team,
I am trying to figure out this calculation from tableau, any help would be much appreciated.
If [Fiscal Year]=([Report as of FY]-1) and INT([Fiscal Period])<= INT([Report as of Fiscal Period])
then [Sales Revenue in USD (M)] ELSE 0 END
Solved! Go to Solution.
Hi @g-wizard
Please try this:
IF (
[Fiscal Year] = [Report as of FY] - 1
&& INT[Fiscal Period] <= INT[Report as of Fiscal Period],//logicaltext
[Sales Revenue in USD (M)]//result if true
)
Here is the link of If function:
IF function (DAX) - DAX | Microsoft Learn
Dax Overview:
DAX overview - DAX | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @g-wizard
Please try this:
IF (
[Fiscal Year] = [Report as of FY] - 1
&& INT[Fiscal Period] <= INT[Report as of Fiscal Period],//logicaltext
[Sales Revenue in USD (M)]//result if true
)
Here is the link of If function:
IF function (DAX) - DAX | Microsoft Learn
Dax Overview:
DAX overview - DAX | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
in DAX:
Sales Revenue in USD (M) = IF ( [Fiscal Year] = [Report as of FY] - 1 && INT([Fiscal Period]) <= INT([Report as of Fiscal Period]), [Sales Revenue in USD (M)], 0 )
IF(some comparison,result if true,[result if false)
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |