Forum Discussion
Solved
Measure to isolate specific field
Hi all - new to this! have been using Qlikview for years and now we are transferring over to PowerBI so need to brush up on syntax used for certain measures. I use the measure = DISTINCTCOUNT('T...
Please see the attached PBIX, created a measure that could work
richbenmintz
If I wanted to compare current month, using the above 'Average Per Month' measure syntax - against last months average, how would this look? Or against the same month, two years ago, or against a specific month such as 2019-03??
Can PowerBI do this easily, without me needing to change the syntax every month to suit?
Hi Creative_tree88 ,
here is a really great reference for you from the wonderful people at SQLBI, they are pretty much the best!