Forum Discussion
Calculate Transactions
Hi, I am having treouble creating a measure: I have a table with the information below. I want to know the Total number of Cage installations that were completed (date completed) during the same...
Hi,
Here's one crude way without creating a Calendar Table. Write a calculated column formula (column title is month-year check)
month-year check = format(Data[job site start date],"mmyy")=format(Data[Date completed],"mmyy")
Write this mesure and drag it to a card visual
Measure = calculate(sum(data[cage installation]),data[month-year check]=TRUE())
Hope this helps.